OpenEdge Data Management:<br />Database Administration OpenEdge Release 10 database log file

The OpenEdge database log is a text file that contains a history of significant database events and parameter settings. The log file includes startup parameter settings, the date and time of startup and shutdown, system error messages, and utility and maintenance activity. This file has a .lg extension. Entries in the database log can help you trace events preceding database crashes.

The format of each entry in the database log file provides detailed information about the time the event occurred, the source of the event, and the text of the associated message and message number. A database log entry is formatted as follows:

[yy/mm/dd@hh:mm:ss.uuushhmm] P-nnnnnn T-nnnnnn S name nnn: (nnnnn) Message

Table 16–1 describes the fields of each entry in the log file. All fields, with the exception of the message text, have a fixed width.

Table 16–1: Database event log format
Field in log entry	Description
yy/mm/dd	Date in year/month/day format.
hh:mm:ss.uuu	Local time in hours, minutes, seconds, milliseconds
shhmm	Time zone relative to GMT where `s` is a `+` or `-` and `hhmm` are hours and minutes. For example, a value of -0500 represents a time zone five hours behind GMT.
P-nnnnnn	The process id of the process that produced the message. The process id is blank for remote clients. Space is allocated for a maximum of 10 digits in the process id.
T-nnnnn	The thread id of the thread that produced the message. In Windows, thread ids are unique across a system; there is no implied relationship between a thread id and the thread’s creation order. On UNIX, thread ids are unique to a process. The id of the main thread is 1, and additional threads will be numbered in order. Space is allocated for a maximum of 5 digits in the thread id.
S	The severity level of the message. There are three possible values: I—informational message W—warning message F—fatal message
name nnn:	User name and user number. These two items create single field to identify the source of the message. Possible values include: BROKER 0:, USR 5:, RPLS 5: DBUTIL:, etc. Nine spaces are allocated for this field. The name portion is left justified and the user number is right justified.
(nnnnn)	The message number of the message. More details about the message can be obtained by accessing Help Messages... from the OpenEdge Desktop.
Message text...	The text of the message.